Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM00300
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Address MSTR Group Display Name: Payables Vendor Master Logical File
Physical Name: PM00300
Technical Name: PM_Address_MSTR
Group Technical Name: PM_Vendor_Master_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | VENDORID  | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PM Address MSTR'].VENDORID AS 'PM Address MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM00300 AS ['PM Address MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Address MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 2 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 | |
Partial key to the Address Electronic Funds Transfer Master (SY06000).
Click to show/hideSELECT
['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
,['Address Electronic Funds Transfer Master'].ADRSCODE AS 'Address Electronic Funds Transfer Master-Address Code'
FROM
PM00300 AS ['PM Address MSTR']
INNER JOIN
SY06000 AS ['Address Electronic Funds Transfer Master']
ON
['PM Address MSTR'].ADRSCODE = ['Address Electronic Funds Transfer Master'].ADRSCODE
AND
['PM Address MSTR'].VENDORID = ['Address Electronic Funds Transfer Master'].VENDORID
AND
['Address Electronic Funds Transfer Master'].SERIES = 4Click to show/hideSELECT
['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
,['Internet Addresses'].ADRSCODE AS 'Internet Addresses-Address Code'
FROM
PM00300 AS ['PM Address MSTR']
INNER JOIN
SY01200 AS ['Internet Addresses']
ON
['PM Address MSTR'].ADRSCODE = ['Internet Addresses'].ADRSCODE
AND
['PM Address MSTR'].VENDORID = ['Internet Addresses'].Master_ID
AND
['Internet Addresses'].Master_Type = 'VEN' | ||||||
| 3 | VNDCNTCT | Vendor Contact | String | STR60 | 60 | |
| 4 | ADDRESS1 | Address 1 | String | STR60 | 60 | |
| 5 | ADDRESS2 | Address 2 | String | STR60 | 60 | |
| 6 | ADDRESS3 | Address 3 | String | STR60 | 60 | |
| 7 | CITY | City | String | STR35 | 35 | |
| 8 | STATE | State | String | STR30_State | 29 | |
| 9 | ZIPCODE | Zip Code | String | STR10 | 10 | |
| 10 | COUNTRY | Country | String | STR60 | 60 | |
| 11 | UPSZONE | UPS Zone | String | STR3 | 3 | |
| 12 | PHNUMBR1 | Phone Number 1 | String | Phone_Number | 14 | |
| 13 | PHNUMBR2 | Phone Number 2 | String | Phone_Number | 14 | |
| 14 | PHONE3 | Phone 3 | String | Phone_Number3 | 14 | |
| 15 | FAXNUMBR | Fax Number | String | STR14_FAX | 14 | |
| 16 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['PM Address MSTR'].SHIPMTHD AS 'PM Address MSTR-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PM00300 AS ['PM Address MSTR']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PM Address MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 17 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PM Address MSTR'].TAXSCHID AS 'PM Address MSTR-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM00300 AS ['PM Address MSTR']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Address MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 18 | EmailPOs | Email Purchase Orders | Boolean | CB_EmailPurchaseOrders | 0 | |
| 19 | POEmailRecipient | Purchase Order Email Recipient | String | STR80 | 80 | |
| 20 | EmailPOFormat | Email PO Format | Integer | DDL_PO_DocDeliveryFormat | 0 | |
| 21 | FaxPOs | Fax Purchase Orders | Boolean | CB_FaxPurchaseOrders | 0 | |
| 22 | POFaxNumber | Purchase Order Fax Number | String | STR14_FAX | 14 | |
| 23 | FaxPOFormat | Fax PO Format | Integer | DDL_PO_DocDeliveryFormat | 0 | |
| 24 | CCode | Country Code | String | STR6_VAT | 6 | |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['PM Address MSTR'].CCode AS 'PM Address MSTR-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
PM00300 AS ['PM Address MSTR']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['PM Address MSTR'].CCode = ['VAT Country Code MSTR'].CCode | ||||||
| 25 | DECLID | Declarant ID | String | STR15_Address_Code | 15 | |